<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"><title>query data</title>
<style type="text/css" <!--
.normal {  font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 12px; font-weight: normal; color: #000000}
.medium {  font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 15px; font-weight: bold; color: #000000; text-decoration: none}
--></style>
</head>
<body>
<h3>query result</h3><table border=1>
<tr>
<td bgcolor=silver class='medium'>sqlquery</td></tr>
<tr>
<td class='normal' valign='top'>SELECT COUNT(DISTINCT assessmentid) as asmtcount FROM assessment_field_descriptions WHERE fieldflag LIKE 'armt%' or fieldflag LIKE 'ahsge%' HAVING asmtcount &gt;= 2</td>
</tr>
<tr>
<td class='normal' valign='top'>SELECT COUNT(DISTINCT assessmentid) as asmtcount FROM assessment_field_descriptions WHERE fieldflag LIKE 'abe%' HAVING asmtcount &gt;= 2</td>
</tr>
<tr>
<td class='normal' valign='top'>SELECT COUNT(DISTINCT assessmentid) as asmtcount FROM assessment_field_descriptions WHERE fieldflag LIKE 'aims%' HAVING asmtcount &gt;= 2</td>
</tr>
<tr>
<td class='normal' valign='top'>SELECT COUNT(DISTINCT assessmentid) as asmtcount FROM assessment_field_descriptions WHERE fieldflag LIKE 'meap%' OR fieldflag LIKE 'cst%' OR fieldflag LIKE 'taks%' OR fieldflag LIKE 'celdt%' HAVING asmtcount &gt;= 2</td>
</tr>
<tr>
<td class='normal' valign='top'>SELECT COUNT(DISTINCT assessmentid) as asmtcount FROM assessment_field_descriptions WHERE fieldflag LIKE 'csap%' HAVING asmtcount &gt;= 2</td>
</tr>
<tr>
<td class='normal' valign='top'>SELECT COUNT(DISTINCT assessmentid) as asmtcount FROM assessment_field_descriptions WHERE fieldflag LIKE 'fcat%' HAVING asmtcount &gt;= 2</td>
</tr>
<tr>
<td class='normal' valign='top'>SELECT COUNT(DISTINCT assessmentid) as asmtcount FROM assessment_field_descriptions WHERE fieldflag LIKE 'eoct%' OR fieldflag LIKE 'crct%' HAVING asmtcount &gt;= 2</td>
</tr>
<tr>
<td class='normal' valign='top'>SELECT COUNT(DISTINCT assessmentid) as asmtcount FROM assessment_field_descriptions WHERE fieldflag LIKE 'isat%' OR fieldflag LIKE 'iaa%' HAVING asmtcount &gt;= 2</td>
</tr>
<tr>
<td class='normal' valign='top'>SELECT COUNT(DISTINCT assessmentid) as asmtcount FROM assessment_field_descriptions WHERE fieldflag LIKE 'kcct%' HAVING asmtcount &gt;= 2</td>
</tr>
<tr>
<td class='normal' valign='top'>SELECT COUNT(DISTINCT assessmentid) as asmtcount FROM assessment_field_descriptions WHERE fieldflag LIKE 'mcas%' HAVING asmtcount &gt;= 2</td>
</tr>
<tr>
<td class='normal' valign='top'>SELECT COUNT(DISTINCT assessmentid) as asmtcount FROM assessment_field_descriptions WHERE fieldflag LIKE 'msa%' HAVING asmtcount &gt;= 2</td>
</tr>
<tr>
<td class='normal' valign='top'>SELECT COUNT(DISTINCT assessmentid) as asmtcount FROM assessment_field_descriptions WHERE fieldflag LIKE 'meap%' OR fieldflag LIKE 'cst%' OR fieldflag LIKE 'taks%' OR fieldflag LIKE 'celdt%' HAVING asmtcount &gt;= 2</td>
</tr>
<tr>
<td class='normal' valign='top'>SELECT COUNT(DISTINCT assessmentid) as asmtcount FROM assessment_field_descriptions WHERE fieldflag LIKE 'mca%' HAVING asmtcount &gt;= 2</td>
</tr>
<tr>
<td class='normal' valign='top'>SELECT COUNT(DISTINCT assessmentid) as asmtcount FROM assessment_field_descriptions WHERE fieldflag LIKE 'map%' HAVING asmtcount &gt;= 2</td>
</tr>
<tr>
<td class='normal' valign='top'>SELECT COUNT(DISTINCT assessmentid) as asmtcount FROM assessment_field_descriptions WHERE fieldflag LIKE 'nceog%' HAVING asmtcount &gt;= 2</td>
</tr>
<tr>
<td class='normal' valign='top'>SELECT COUNT(DISTINCT assessmentid) as asmtcount FROM assessment_field_descriptions WHERE fieldflag LIKE 'nesa%' HAVING asmtcount &gt;= 2;</td>
</tr>
<tr>
<td class='normal' valign='top'>SELECT COUNT(DISTINCT assessmentid) as asmtcount FROM assessment_field_descriptions WHERE fieldflag LIKE 'njask%' HAVING asmtcount &gt;= 2</td>
</tr>
<tr>
<td class='normal' valign='top'>SELECT COUNT(DISTINCT assessmentid) as asmtcount FROM assessment_field_descriptions WHERE fieldflag LIKE 'nmsba%' HAVING asmtcount &gt;= 2</td>
</tr>
<tr>
<td class='normal' valign='top'>SELECT COUNT(DISTINCT assessmentid) as asmtcount FROM assessment_field_descriptions WHERE fieldflag LIKE 'nystp%' HAVING asmtcount &gt;= 2</td>
</tr>
<tr>
<td class='normal' valign='top'>SELECT COUNT(DISTINCT assessmentid) as asmtcount FROM assessment_field_descriptions WHERE fieldflag LIKE 'oaa%' OR fieldflag LIKE 'ogt%' HAVING asmtcount &gt;= 2</td>
</tr>
<tr>
<td class='normal' valign='top'>SELECT COUNT(DISTINCT assessmentid) as asmtcount FROM assessment_field_descriptions WHERE fieldflag LIKE 'tcap%' HAVING asmtcount &gt;= 2</td>
</tr>
<tr>
<td class='normal' valign='top'>SELECT COUNT(DISTINCT assessmentid) as asmtcount FROM assessment_field_descriptions WHERE fieldflag LIKE 'meap%' OR fieldflag LIKE 'cst%' OR fieldflag LIKE 'taks%' OR fieldflag LIKE 'celdt%' HAVING asmtcount &gt;= 2</td>
</tr>
<tr>
<td class='normal' valign='top'>SELECT COUNT(DISTINCT assessmentid) as asmtcount FROM assessment_field_descriptions WHERE fieldflag LIKE 'sol%' HAVING asmtcount &gt;= 2</td>
</tr>
<tr>
<td class='normal' valign='top'>SELECT COUNT(DISTINCT assessmentid) as asmtcount FROM assessment_field_descriptions WHERE fieldflag LIKE 'wasl%' HAVING asmtcount &gt;= 2</td>
</tr>
<tr>
<td class='normal' valign='top'>SELECT COUNT(DISTINCT assessmentid) as asmtcount FROM assessment_field_descriptions WHERE fieldflag LIKE 'wkce%' HAVING asmtcount &gt;= 2</td>
</tr>
<tr>
<td class='normal' valign='top'>SELECT COUNT(DISTINCT assessmentid) as asmtcount FROM assessment_field_descriptions WHERE fieldflag LIKE 'westtest2%' HAVING asmtcount &gt;= 2</td>
</tr>
</table>
</body></html>